Hệ thống quản lý bệnh viện bằng C# với mã nguồn
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="hospitalDataSet2" targetNamespace="http://tempuri.org/hospitalDataSet2.xsd" xmlns:mstns="http://tempuri.org/hospitalDataSet2.xsd" xmlns="http://tempuri.org/hospitalDataSet2.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3 <xs:annotation>
4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6 <Connections>
7 <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="hospitalConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="hospitalConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.HospitalManagementSystemCSharp.Properties.Settings.GlobalReference.Default.hospitalConnectionString" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="roomTableAdapter" GeneratorDataComponentClassName="roomTableAdapter" Name="room" UserDataComponentName="roomTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="hospitalConnectionString (Settings)" DbObjectName="dbo.room" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <DeleteCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>DELETE FROM [dbo].[room] WHERE (([Id] = @Original_Id) AND ((@IsNull_building = 1 AND [building] IS NULL) OR ([building] = @Original_building)) AND ((@IsNull_r_type = 1 AND [r_type] IS NULL) OR ([r_type] = @Original_r_type)) AND ((@IsNull_r_no = 1 AND [r_no] IS NULL) OR ([r_no] = @Original_r_no)) AND ((@IsNull_no_bed = 1 AND [no_bed] IS NULL) OR ([no_bed] = @Original_no_bed)) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)) AND ((@IsNull_r_status = 1 AND [r_status] IS NULL) OR ([r_status] = @Original_r_status)))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_building" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="true" SourceVersion="Original" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_building" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="false" SourceVersion="Original" />
20 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="true" SourceVersion="Original" />
21 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Original" />
22 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="true" SourceVersion="Original" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Original" />
24 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_no_bed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="no_bed" SourceColumnNullMapping="true" SourceVersion="Original" />
25 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_no_bed" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="no_bed" SourceColumnNullMapping="false" SourceVersion="Original" />
26 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="true" SourceVersion="Original" />
27 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Original" />
28 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_status" SourceColumnNullMapping="true" SourceVersion="Original" />
29 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_status" SourceColumnNullMapping="false" SourceVersion="Original" />
30 </Parameters>
31 </DbCommand>
32 </DeleteCommand>
33 <InsertCommand>
34 <DbCommand CommandType="Text" ModifiedByUser="false">
35 <CommandText>INSERT INTO [dbo].[room] ([building], [r_type], [r_no], [no_bed], [price], [r_status]) VALUES (@building, @r_type, @r_no, @no_bed, @price, @r_status);
36 SELECT Id, building, r_type, r_no, no_bed, price, r_status FROM room WHERE (Id = SCOPE_IDENTITY())</CommandText>
37 <Parameters>
38 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@building" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="false" SourceVersion="Current" />
39 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Current" />
40 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Current" />
41 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@no_bed" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="no_bed" SourceColumnNullMapping="false" SourceVersion="Current" />
42 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
43 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_status" SourceColumnNullMapping="false" SourceVersion="Current" />
44 </Parameters>
45 </DbCommand>
46 </InsertCommand>
47 <SelectCommand>
48 <DbCommand CommandType="Text" ModifiedByUser="false">
49 <CommandText>SELECT Id, building, r_type, r_no, no_bed, price, r_status FROM dbo.room</CommandText>
50 <Parameters />
51 </DbCommand>
52 </SelectCommand>
53 <UpdateCommand>
54 <DbCommand CommandType="Text" ModifiedByUser="false">
55 <CommandText>UPDATE [dbo].[room] SET [building] = @building, [r_type] = @r_type, [r_no] = @r_no, [no_bed] = @no_bed, [price] = @price, [r_status] = @r_status WHERE (([Id] = @Original_Id) AND ((@IsNull_building = 1 AND [building] IS NULL) OR ([building] = @Original_building)) AND ((@IsNull_r_type = 1 AND [r_type] IS NULL) OR ([r_type] = @Original_r_type)) AND ((@IsNull_r_no = 1 AND [r_no] IS NULL) OR ([r_no] = @Original_r_no)) AND ((@IsNull_no_bed = 1 AND [no_bed] IS NULL) OR ([no_bed] = @Original_no_bed)) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)) AND ((@IsNull_r_status = 1 AND [r_status] IS NULL) OR ([r_status] = @Original_r_status)));
56 SELECT Id, building, r_type, r_no, no_bed, price, r_status FROM room WHERE (Id = @Id)</CommandText>
57 <Parameters>
58 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@building" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="false" SourceVersion="Current" />
59 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Current" />
60 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Current" />
61 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@no_bed" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="no_bed" SourceColumnNullMapping="false" SourceVersion="Current" />
62 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
63 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_status" SourceColumnNullMapping="false" SourceVersion="Current" />
64 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
65 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_building" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="true" SourceVersion="Original" />
66 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_building" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="false" SourceVersion="Original" />
67 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="true" SourceVersion="Original" />
68 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Original" />
69 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="true" SourceVersion="Original" />
70 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Original" />
71 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_no_bed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="no_bed" SourceColumnNullMapping="true" SourceVersion="Original" />
72 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_no_bed" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="no_bed" SourceColumnNullMapping="false" SourceVersion="Original" />
73 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="true" SourceVersion="Original" />
74 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Original" />
75 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_status" SourceColumnNullMapping="true" SourceVersion="Original" />
76 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_status" SourceColumnNullMapping="false" SourceVersion="Original" />
77 <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="[F:\Sem.4\C# Projects\Trials\HospitalManagementSystemCSharp\HospitalManagementSystemCSharp\HOSPITAL.MDF].dbo.room" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
78 </Parameters>
79 </DbCommand>
80 </UpdateCommand>
81 </DbSource>
82 </MainSource>
83 <Mappings>
84 <Mapping SourceColumn="Id" DataSetColumn="Id" />
85 <Mapping SourceColumn="building" DataSetColumn="building" />
86 <Mapping SourceColumn="r_type" DataSetColumn="r_type" />
87 <Mapping SourceColumn="r_no" DataSetColumn="r_no" />
88 <Mapping SourceColumn="no_bed" DataSetColumn="no_bed" />
89 <Mapping SourceColumn="price" DataSetColumn="price" />
90 <Mapping SourceColumn="r_status" DataSetColumn="r_status" />
91 </Mappings>
92 <Sources />
93 </TableAdapter>
94 </Tables>
95 <Sources />
96 </DataSource>
97 </xs:appinfo>
98 </xs:annotation>
99 <xs:element name="hospitalDataSet2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="hospitalDataSet2" msprop:Generator_UserDSName="hospitalDataSet2">
100 <xs:complexType>
101 <xs:choice minOccurs="0" maxOccurs="unbounded">
102 <xs:element name="room" msprop:Generator_TableClassName="roomDataTable" msprop:Generator_TableVarName="tableroom" msprop:Generator_TablePropName="room" msprop:Generator_RowDeletingName="roomRowDeleting" msprop:Generator_RowChangingName="roomRowChanging" msprop:Generator_RowEvHandlerName="roomRowChangeEventHandler" msprop:Generator_RowDeletedName="roomRowDeleted" msprop:Generator_UserTableName="room" msprop:Generator_RowChangedName="roomRowChanged" msprop:Generator_RowEvArgName="roomRowChangeEvent" msprop:Generator_RowClassName="roomRow">
103 <xs:complexType>
104 <xs:sequence>
105 <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
106 <xs:element name="building" msprop:Generator_ColumnVarNameInTable="columnbuilding" msprop:Generator_ColumnPropNameInRow="building" msprop:Generator_ColumnPropNameInTable="buildingColumn" msprop:Generator_UserColumnName="building" minOccurs="0">
107 <xs:simpleType>
108 <xs:restriction base="xs:string">
109 <xs:maxLength value="50" />
110 </xs:restriction>
111 </xs:simpleType>
112 </xs:element>
113 <xs:element name="r_type" msprop:Generator_ColumnVarNameInTable="columnr_type" msprop:Generator_ColumnPropNameInRow="r_type" msprop:Generator_ColumnPropNameInTable="r_typeColumn" msprop:Generator_UserColumnName="r_type" minOccurs="0">
114 <xs:simpleType>
115 <xs:restriction base="xs:string">
116 <xs:maxLength value="50" />
117 </xs:restriction>
118 </xs:simpleType>
119 </xs:element>
120 <xs:element name="r_no" msprop:Generator_ColumnVarNameInTable="columnr_no" msprop:Generator_ColumnPropNameInRow="r_no" msprop:Generator_ColumnPropNameInTable="r_noColumn" msprop:Generator_UserColumnName="r_no" minOccurs="0">
121 <xs:simpleType>
122 <xs:restriction base="xs:string">
123 <xs:maxLength value="50" />
124 </xs:restriction>
125 </xs:simpleType>
126 </xs:element>
127 <xs:element name="no_bed" msprop:Generator_ColumnVarNameInTable="columnno_bed" msprop:Generator_ColumnPropNameInRow="no_bed" msprop:Generator_ColumnPropNameInTable="no_bedColumn" msprop:Generator_UserColumnName="no_bed" minOccurs="0">
128 <xs:simpleType>
129 <xs:restriction base="xs:string">
130 <xs:maxLength value="50" />
131 </xs:restriction>
132 </xs:simpleType>
133 </xs:element>
134 <xs:element name="price" msprop:Generator_ColumnVarNameInTable="columnprice" msprop:Generator_ColumnPropNameInRow="price" msprop:Generator_ColumnPropNameInTable="priceColumn" msprop:Generator_UserColumnName="price" minOccurs="0">
135 <xs:simpleType>
136 <xs:restriction base="xs:string">
137 <xs:maxLength value="50" />
138 </xs:restriction>
139 </xs:simpleType>
140 </xs:element>
141 <xs:element name="r_status" msprop:Generator_ColumnVarNameInTable="columnr_status" msprop:Generator_ColumnPropNameInRow="r_status" msprop:Generator_ColumnPropNameInTable="r_statusColumn" msprop:Generator_UserColumnName="r_status" minOccurs="0">
142 <xs:simpleType>
143 <xs:restriction base="xs:string">
144 <xs:maxLength value="50" />
145 </xs:restriction>
146 </xs:simpleType>
147 </xs:element>
148 </xs:sequence>
149 </xs:complexType>
150 </xs:element>
151 </xs:choice>
152 </xs:complexType>
153 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
154 <xs:selector xpath=".//mstns:room" />
155 <xs:field xpath="mstns:Id" />
156 </xs:unique>
157 </xs:element>
158 </xs:schema>